﻿USE [GameServicesDB]
GO

INSERT INTO [GameServicesDB].[games].[Games]
           ([GameHash]
           ,[Name]
           ,[NormalizedName])
     VALUES
           ('E47552CF-AF1F-4cb6-BA2E-3F7289F98233'
           ,'Catch Eggs'
           ,'catcheggs'),
           ('E47552CF-AF1F-4cb6-BA2E-3F7289F98234'
           ,'Some other game'
           ,'someothergame')
GO

-- DUMMY RESULTS
INSERT INTO [GameServicesDB].[games].[GameResult]
           ([GameId], [Score], [DateTime], [PlayerName], [DeviceId])
     VALUES 
	 (1, 123, GETDATE(), 'Maciej Grabek', 'device1'),
	 (1, 12, GETDATE(), 'John Smith', 'device2'),
	 (2, 123, GETDATE(), 'Maciej Grabek', 'device1'),
	 (2, 12, GETDATE(), 'John Smith', 'device2'),
GO

